Model Table COMPANY
This model dimension represents the financial companies. In the Group Consolidation model it represnts the master company only. The dimensionis based on the
IFS Cloud dimension DIM_COMPANY. All models that
refers to this dimension will have the attributes and hierarchies as described
below.
Attributes
| Attribute |
Description (where applicable) |
| Company | Built as CODE + ' - ' + NAME + ' (' + CURRENCY_CODE + ')' |
| Company Code | Represents the CODE of the dimension (company) |
| Company Code Name | Name of the company built as CODE + ' - ' + NAME |
| Company Country Code | Represents the COUNTRY code of the company |
| Company Currency | Represents the CURRENCY_CODE of the company |
| Company Name | Represents the NAME of the company |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| COMPANY | DIM_COMPANY_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |